Budget Labor Override

Overview

Use this driver to make overrides to the various labor-related sheets, such as Empl_List, in budget plan files. You can configure labor overrides at the following levels:

  • Global
  • Budget Groups
  • Department Exceptions
  • Department - Jobcode Exceptions

The plan file calc methods process the overrides by first evaluating for exceptions at the job code level, then department exceptions, budget group exceptions, and then finally applies the default settings at the global level.

Labor Overrides allow you to modify how the Jobcode, Staffing, and Employee tabs calculate salaries and related statistics and expenses.

You can adjust the following items:

  • The source for Regular and PTO pay
  • The source for PTO and EPTO FTEs
  • The spread of pay across pay types

Settings

Open the driver, and then use the following table to complete the driver settings, as needed:

Option Definition
Department The department in which to apply the labor override.
Jobcode

The job code for the specified department to apply the labor override.

NOTE: This column is only editable in the Department - Jobcode Exceptions section.
Regular Rate Source

Select the Regular Rate Source to use for the beginning budget rate for each job code.

  • History – Uses the historic rate based on the most recent current period actual.
  • Base – Uses the base rate from the Employee Master sheet.
  • Global – Uses the rate of pay entered on this tab in the Rate Override Amount column.
Rate Override Amount

Enter the override amount.

NOTE: This column is only editable in the Department - Jobcode Exceptions section.
PTO Rate Source

Select the beginning PTO budget rate for each job code.

  • Base – Uses the rate listed on the Employee Master sheet.
  • Regular – Uses the Regular pay rate for PTO.
PTO FTE Source

Select the source of FTE for PTO Calculation.

  • YTD – Uses actual Year-to-Date FTE.
  • Rolling12 – Uses 12-month actual (full year) FTE.
  • EPTO – Uses the EPTO rate based on scheduled. This may not match the actual EPTO rate.
EPTO% Override

Enter one of the following to override the calculated EPTO% from the Empl_List:

  • A percentage to override the standard PTO calculation.
  • History or NA - If you do not want to adjust the EPTO%, enter NA, and the default lookup to Emp_List logic applies.

IMPORTANT: Do not enter zero (0), because zero is a valid adjustment percentage.

Adjustment to Calculated PTO% Modify the EPTO% used on the PTO row. This is a data validation entry field, with a range from 0%-200%. For example, if the EPTO% for a selected job code is 8%, and you enter 100% as the default in this column, the value remains at 8% (i.e. 8% x 100% = 8%). If you enter the adjustments to calculated EPTO% as 80%. then 6.4% would display as the value on the PTO row.
EPTO FTE Source

Select the source of the FTE for Earned PTO Calculation, if that option is enabled on the Configuration sheet.

  • YTD – The YTD FTE.
  • Scheduled – The scheduled FTEs from the Employee Master sheet.
Paytype Distribution Overrides

Enter the Override FTE Allocation percentages by category. For each category, do one of the following:

  • Enter a percentage.
  • To use the historical percentage by category by job code, select History.

NOTE: History is the default. You can enter or modify this value. There are several columns available, for both Prod and NonProd entries.

Adding a new row to a section

To add a new row to a section, click the Double Click to Insert New Budget Group/Dept Exception/Jobcode Exception row.

Displaying the legend

The Labor Override Legend provides descriptions that corresponds to specified columns. The letter next to the description corresponds to the letter that displays above the column, as seen in the following screen shot.

By default, the legend is hidden. To display it, in the Main ribbon tab, click Change View > Legend.

To hide the legend, in the Main ribbon tab, click Change View > Default.

NOTE: When you close and reopen the driver, the system automatically hides the legend.